Publish your Form

Publishing a form involves converting your Digitise Forms project into the required files for your website, deploying these files to the website and creating any required databases.

Form Studio can publish your forms to a local website on the same machine or to a remote web server.

If your project contains more than one form, all the forms in the project will be published.

 

The Digitise Forms website files are split into two components:

Digitise Forms uses Web Deploy to assist in publishing your forms. Web Deploy is a Microsoft tool designed to simplify deploying and managing IIS websites. When you publish a form, Form Studio creates a Web Deploy deployment package, containing the Client and Server files, which is used to automatically deploy your form to your chosen website for you. Web Deploy v3.6 is required on both your development PCs and on any IIS web servers to which you want to deploy forms. This utility should have been installed by the Digitise Forms setup, but if not, you can download Web Deploy free of charge from Microsoft's website. At the time of writing it was available here.

 

To publish the forms in your current project, choose File ➝ Publish. The Publish screen will be displayed. The first time you load the Publish screen within a project it will look like this:

Picture showing initial empty Publish page in Form Studio.

You must create a Publishing Profile before you can publish your project for the first time. Changes to a Profile are saved automatically.

When you create a new Profile, the Profile settings will be displayed. Once you have created at least one Profile, when you load the Publish screen the last used Profile will automatically be selected and its settings will be displayed. The Profile settings will look something like this:

Picture showing initial empty Publish profile settings in Form Studio.

If this is a new Profile you can now configure the settings.

If you want to change an existing Profile, select the required Profile in the Profile drop-down list at the top of the screen if it isn't already selected. The Profile's configuration settings will be displayed and you can then edit them.

 

 

Once you have a suitably configured Profile you can publish your project.

If you want to publish your project using an existing Profile, select it in the Profile option at the top of the screen, if it isn't already selected. The Profile's settings will be displayed and you can make changes if you need to before you publish.

  • If you have made changes to the structure of any of your Datasources, e.g. adding a new column or changing a column name, we recommend you take a backup of your existing database(s) before you publish the form and update the database(s). In addition, if you have changed any element mappings related to the amended Datasource, you will need to re-generate and save the Word template if you plan on using a form PDF. See the Create PDF Copies of Completed Forms topic for more details.

 

When you are ready to publish, use the Publish button at the bottom of the screen:

Picture showing the Publish button.

The Publish button generates the Client and Server files, creates the deployment package, creates/updates any required Digitise Forms databases and deploys the form(s) to the website, in accordance with the values in the currently selected Profile.

A progress bar will be displayed along with messages showing you the progress of the publish.

Form Studio will make various checks on your project, e.g. to check for changes to Datasources, and will display a list of warnings and errors if the checks generate any. If you have made changes to the structure of existing Datasources, e.g. adding or deleting columns, changing column names, changing whether a column can contain Nulls etc. the list will warn you about your changes and whether existing data may be at risk if you upgrade the existing databases. You will be asked to confirm that you want to make the changes. You can choose to upgrade the existing database, converting existing data if necessary, delete the current database and create a new one or abandon the publish. Invalid changes will prevent the form from being published.

  • If when attempting to create a Digitise Forms database, the Digitise Forms Publisher is unable to log in to the specified SQL Server instance or the user specified doesn't have permissions to create the database(s), you will be given the opportunity to enter a different connection string using credentials which have the correct permissions. In the case of a failed login, you will be asked whether you want to save this new connection string, overwriting the original one. In the case of insufficient permissions, your new connection string is only temporary and will be deleted after using it to create the database(s).
  • If an existing Digitise Forms database cannot be dropped before being recreated, you will be given the chance to close the existing connections and retry.
  • With Digitise Forms Datasources, data is only stored in a database table when the database is created. If you later want to change the values stored, e.g. you want to add an extra item to a Check List or Radio List, you can do this in one of the following ways:
    • Delete the existing database and recreate it:

      Edit the data in the appropriate Dataset and then change the name of the Dataset (see Create and Manage Datasets). The name change will automatically be applied to any relevant existing Element data mappings. Republish the form and Choose Drop and create new database when asked how you want your changes to be implemented.

      This will delete the current database and create a new one, including storing your new data items. Since the original database will be deleted, any existing data in it, which won't be restored by your Datasource definitions, will be lost. We recommend, therefore, that you backup or extract the data before you make the changes.

      If you want to retain the original name of the Dataset, you can rename the Dataset back to its original name and republish. This time, choose Upgrade existing data to apply your changes, as this will upgrade the existing database without deleting it.

    • Edit the data outside Form Studio, e.g. using Microsoft's SQL Server Management Studio.

 

The first time you publish a form it may take a few minutes to complete all the stages and create any databases required. If you make changes to a form and republish it later, subsequent publishes will usually be quicker.

 

Once your form has been published successfully, you can then run it within a browser using the URL displayed in the Publishing Profile's URL field - see Forms category under Profile Settings above.

 

You can check when a project was last published by looking in the Info section available from the File Menu.